Overview
Brought to you by YData
Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 3732 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 2 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 861.5 KiB |
| Average record size in memory | 236.4 B |
Variable types
| Categorical | 1 |
|---|---|
| Text | 1 |
| Numeric | 9 |
| Boolean | 1 |
| Dataset has 2 (0.1%) duplicate rows | Duplicates |
discountPercent has 1178 (31.6%) zeros | Zeros |
availableQuantity has 453 (12.1%) zeros | Zeros |
total_revenue has 454 (12.2%) zeros | Zeros |
discountValue has 1169 (31.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-14 14:41:46.754627 |
|---|---|
| Analysis finished | 2025-07-14 14:42:11.130104 |
| Duration | 24.38 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Category
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 261.2 KiB |
| Cooking Essentials | |
|---|---|
| Munchies | |
| Packaged Food | |
| Ice Cream & Desserts | |
| Chocolates & Candies | |
| Other values (9) |
Length
| Max length | 21 |
|---|---|
| Median length | 19 |
| Mean length | 14.628349 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fruits & Vegetables |
|---|---|
| 2nd row | Fruits & Vegetables |
| 3rd row | Fruits & Vegetables |
| 4th row | Fruits & Vegetables |
| 5th row | Fruits & Vegetables |
Common Values
| Value | Count | Frequency (%) |
| Cooking Essentials | 514 | |
| Munchies | 514 | |
| Packaged Food | 388 | |
| Ice Cream & Desserts | 388 | |
| Chocolates & Candies | 388 | |
| Personal Care | 344 | |
| Paan Corner | 344 | |
| Home & Cleaning | 194 | 5.2% |
| Biscuits | 147 | 3.9% |
| Dairy, Bread & Batter | 129 | 3.5% |
| Other values (4) | 382 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 1352 | 15.7% | |
| cooking | 514 | 6.0% |
| munchies | 514 | 6.0% |
| essentials | 514 | 6.0% |
| packaged | 388 | 4.5% |
| food | 388 | 4.5% |
| ice | 388 | 4.5% |
| cream | 388 | 4.5% |
| desserts | 388 | 4.5% |
| chocolates | 388 | 4.5% |
| Other values (19) | 3384 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6442 | 11.8% |
| s | 5138 | 9.4% |
| 4874 | 8.9% | |
| a | 4793 | 8.8% |
| o | 3462 | 6.3% |
| n | 3447 | 6.3% |
| i | 2800 | 5.1% |
| r | 2761 | 5.1% |
| C | 2560 | 4.7% |
| t | 2041 | 3.7% |
| Other values (22) | 16275 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 54593 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 6442 | 11.8% |
| s | 5138 | 9.4% |
| 4874 | 8.9% | |
| a | 4793 | 8.8% |
| o | 3462 | 6.3% |
| n | 3447 | 6.3% |
| i | 2800 | 5.1% |
| r | 2761 | 5.1% |
| C | 2560 | 4.7% |
| t | 2041 | 3.7% |
| Other values (22) | 16275 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 54593 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 6442 | 11.8% |
| s | 5138 | 9.4% |
| 4874 | 8.9% | |
| a | 4793 | 8.8% |
| o | 3462 | 6.3% |
| n | 3447 | 6.3% |
| i | 2800 | 5.1% |
| r | 2761 | 5.1% |
| C | 2560 | 4.7% |
| t | 2041 | 3.7% |
| Other values (22) | 16275 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 54593 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 6442 | 11.8% |
| s | 5138 | 9.4% |
| 4874 | 8.9% | |
| a | 4793 | 8.8% |
| o | 3462 | 6.3% |
| n | 3447 | 6.3% |
| i | 2800 | 5.1% |
| r | 2761 | 5.1% |
| C | 2560 | 4.7% |
| t | 2041 | 3.7% |
| Other values (22) | 16275 |
name
Text
| Distinct | 1681 |
|---|---|
| Distinct (%) | 45.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 334.4 KiB |
Length
| Max length | 95 |
|---|---|
| Median length | 68 |
| Mean length | 33.938103 |
| Min length | 4 |
Unique
| Unique | 467 ? |
|---|---|
| Unique (%) | 12.5% |
Sample
| 1st row | Onion |
|---|---|
| 2nd row | Tomato Hybrid |
| 3rd row | Tender Coconut |
| 4th row | Coriander Leaves |
| 5th row | Ladies Finger |
| Value | Count | Frequency (%) |
| 764 | 3.8% | |
| masala | 247 | 1.2% |
| popular | 191 | 1.0% |
| essentials | 186 | 0.9% |
| noodles | 163 | 0.8% |
| chicken | 155 | 0.8% |
| ching's | 151 | 0.8% |
| cheese | 135 | 0.7% |
| secret | 133 | 0.7% |
| sauce | 130 | 0.6% |
| Other values (1869) | 17746 |
Most occurring characters
| Value | Count | Frequency (%) |
| 16601 | 13.1% | |
| a | 11161 | 8.8% |
| e | 10625 | 8.4% |
| i | 7321 | 5.8% |
| r | 6931 | 5.5% |
| o | 6309 | 5.0% |
| t | 5827 | 4.6% |
| n | 5528 | 4.4% |
| l | 5452 | 4.3% |
| s | 5194 | 4.1% |
| Other values (71) | 45708 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 126657 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 16601 | 13.1% | |
| a | 11161 | 8.8% |
| e | 10625 | 8.4% |
| i | 7321 | 5.8% |
| r | 6931 | 5.5% |
| o | 6309 | 5.0% |
| t | 5827 | 4.6% |
| n | 5528 | 4.4% |
| l | 5452 | 4.3% |
| s | 5194 | 4.1% |
| Other values (71) | 45708 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 126657 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 16601 | 13.1% | |
| a | 11161 | 8.8% |
| e | 10625 | 8.4% |
| i | 7321 | 5.8% |
| r | 6931 | 5.5% |
| o | 6309 | 5.0% |
| t | 5827 | 4.6% |
| n | 5528 | 4.4% |
| l | 5452 | 4.3% |
| s | 5194 | 4.1% |
| Other values (71) | 45708 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 126657 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 16601 | 13.1% | |
| a | 11161 | 8.8% |
| e | 10625 | 8.4% |
| i | 7321 | 5.8% |
| r | 6931 | 5.5% |
| o | 6309 | 5.0% |
| t | 5827 | 4.6% |
| n | 5528 | 4.4% |
| l | 5452 | 4.3% |
| s | 5194 | 4.1% |
| Other values (71) | 45708 |
mrp
Real number (ℝ)
| Distinct | 266 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15680.118 |
| Minimum | 0 |
|---|---|
| Maximum | 260000 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2300 |
| Q1 | 6000 |
| median | 11000 |
| Q3 | 20000 |
| 95-th percentile | 41000 |
| Maximum | 260000 |
| Range | 260000 |
| Interquartile range (IQR) | 14000 |
Descriptive statistics
| Standard deviation | 16088.808 |
|---|---|
| Coefficient of variation (CV) | 1.0260642 |
| Kurtosis | 40.399968 |
| Mean | 15680.118 |
| Median Absolute Deviation (MAD) | 6200 |
| Skewness | 4.4372905 |
| Sum | 58518200 |
| Variance | 2.5884973 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6000 | 122 | 3.3% |
| 5500 | 94 | 2.5% |
| 12000 | 89 | 2.4% |
| 5000 | 85 | 2.3% |
| 7500 | 80 | 2.1% |
| 11000 | 79 | 2.1% |
| 9900 | 77 | 2.1% |
| 15000 | 76 | 2.0% |
| 3000 | 75 | 2.0% |
| 4000 | 72 | 1.9% |
| Other values (256) | 2883 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1000 | 38 | |
| 1100 | 3 | 0.1% |
| 1200 | 9 | 0.2% |
| 1300 | 2 | 0.1% |
| 1400 | 2 | 0.1% |
| 1500 | 56 | |
| 1600 | 2 | 0.1% |
| 1700 | 4 | 0.1% |
| 1800 | 11 | 0.3% |
| Value | Count | Frequency (%) |
| 260000 | 2 | 0.1% |
| 154900 | 2 | 0.1% |
| 145000 | 2 | 0.1% |
| 125000 | 2 | 0.1% |
| 124000 | 2 | 0.1% |
| 120000 | 2 | 0.1% |
| 109900 | 6 | |
| 105000 | 6 | |
| 100500 | 2 | 0.1% |
| 92500 | 2 | 0.1% |
discountPercent
Real number (ℝ)
Zeros
| Distinct | 42 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6170954 |
| Minimum | 0 |
|---|---|
| Maximum | 51 |
| Zeros | 1178 |
| Zeros (%) | 31.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 25 |
| Maximum | 51 |
| Range | 51 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 9.211733 |
|---|---|
| Coefficient of variation (CV) | 1.2093498 |
| Kurtosis | 6.5885463 |
| Mean | 7.6170954 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2120853 |
| Sum | 28427 |
| Variance | 84.856025 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=42)
| Value | Count | Frequency (%) |
| 0 | 1178 | |
| 10 | 468 | 12.5% |
| 5 | 226 | 6.1% |
| 6 | 213 | 5.7% |
| 9 | 201 | 5.4% |
| 2 | 186 | 5.0% |
| 7 | 127 | 3.4% |
| 15 | 125 | 3.3% |
| 4 | 122 | 3.3% |
| 20 | 113 | 3.0% |
| Other values (32) | 773 |
| Value | Count | Frequency (%) |
| 0 | 1178 | |
| 1 | 44 | 1.2% |
| 2 | 186 | 5.0% |
| 3 | 86 | 2.3% |
| 4 | 122 | 3.3% |
| 5 | 226 | 6.1% |
| 6 | 213 | 5.7% |
| 7 | 127 | 3.4% |
| 8 | 69 | 1.8% |
| 9 | 201 | 5.4% |
| Value | Count | Frequency (%) |
| 51 | 3 | 0.1% |
| 50 | 55 | |
| 49 | 3 | 0.1% |
| 46 | 2 | 0.1% |
| 45 | 2 | 0.1% |
| 43 | 4 | 0.1% |
| 40 | 10 | 0.3% |
| 35 | 2 | 0.1% |
| 33 | 2 | 0.1% |
| 32 | 2 | 0.1% |
availableQuantity
Real number (ℝ)
Zeros
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0085745 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 453 |
| Zeros (%) | 12.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 6 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.2035111 |
|---|---|
| Coefficient of variation (CV) | 0.54969943 |
| Kurtosis | -1.0462062 |
| Mean | 4.0085745 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.66641924 |
| Sum | 14960 |
| Variance | 4.8554612 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 6 | 1620 | |
| 0 | 453 | 12.1% |
| 4 | 414 | 11.1% |
| 3 | 351 | 9.4% |
| 5 | 348 | 9.3% |
| 1 | 301 | 8.1% |
| 2 | 245 | 6.6% |
| Value | Count | Frequency (%) |
| 0 | 453 | 12.1% |
| 1 | 301 | 8.1% |
| 2 | 245 | 6.6% |
| 3 | 351 | 9.4% |
| 4 | 414 | 11.1% |
| 5 | 348 | 9.3% |
| 6 | 1620 |
| Value | Count | Frequency (%) |
| 6 | 1620 | |
| 5 | 348 | 9.3% |
| 4 | 414 | 11.1% |
| 3 | 351 | 9.4% |
| 2 | 245 | 6.6% |
| 1 | 301 | 8.1% |
| 0 | 453 | 12.1% |
discountedSellingPrice
Real number (ℝ)
| Distinct | 350 |
|---|---|
| Distinct (%) | 9.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14192.835 |
| Minimum | 0 |
|---|---|
| Maximum | 139900 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2055 |
| Q1 | 5500 |
| median | 10400 |
| Q3 | 18400 |
| 95-th percentile | 37145 |
| Maximum | 139900 |
| Range | 139900 |
| Interquartile range (IQR) | 12900 |
Descriptive statistics
| Standard deviation | 13850.726 |
|---|---|
| Coefficient of variation (CV) | 0.97589568 |
| Kurtosis | 16.600296 |
| Mean | 14192.835 |
| Median Absolute Deviation (MAD) | 5700 |
| Skewness | 3.2020841 |
| Sum | 52967660 |
| Variance | 1.9184262 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1500 | 59 | 1.6% |
| 2500 | 59 | 1.6% |
| 5500 | 56 | 1.5% |
| 6000 | 47 | 1.3% |
| 4400 | 47 | 1.3% |
| 7500 | 45 | 1.2% |
| 4500 | 44 | 1.2% |
| 9900 | 43 | 1.2% |
| 8000 | 40 | 1.1% |
| 1000 | 39 | 1.0% |
| Other values (340) | 3253 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 900 | 3 | 0.1% |
| 1000 | 39 | |
| 1100 | 3 | 0.1% |
| 1200 | 9 | 0.2% |
| 1300 | 3 | 0.1% |
| 1400 | 1 | < 0.1% |
| 1500 | 59 | |
| 1600 | 5 | 0.1% |
| 1700 | 12 | 0.3% |
| Value | Count | Frequency (%) |
| 139900 | 2 | |
| 130500 | 2 | |
| 124000 | 2 | |
| 114300 | 2 | |
| 105000 | 2 | |
| 103900 | 2 | |
| 103500 | 2 | |
| 99900 | 2 | |
| 98400 | 2 | |
| 92500 | 2 |
weightInGms
Real number (ℝ)
| Distinct | 158 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 387.84378 |
| Minimum | 0 |
|---|---|
| Maximum | 10000 |
| Zeros | 4 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 100 |
| median | 225 |
| Q3 | 450 |
| 95-th percentile | 1000 |
| Maximum | 10000 |
| Range | 10000 |
| Interquartile range (IQR) | 350 |
Descriptive statistics
| Standard deviation | 678.09651 |
|---|---|
| Coefficient of variation (CV) | 1.7483753 |
| Kurtosis | 66.049269 |
| Mean | 387.84378 |
| Median Absolute Deviation (MAD) | 155 |
| Skewness | 6.9886891 |
| Sum | 1447433 |
| Variance | 459814.88 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 200 | 410 | 11.0% |
| 500 | 388 | 10.4% |
| 100 | 285 | 7.6% |
| 1000 | 213 | 5.7% |
| 400 | 213 | 5.7% |
| 250 | 171 | 4.6% |
| 50 | 124 | 3.3% |
| 150 | 95 | 2.5% |
| 300 | 93 | 2.5% |
| 60 | 84 | 2.3% |
| Other values (148) | 1656 |
| Value | Count | Frequency (%) |
| 0 | 4 | 0.1% |
| 1 | 2 | 0.1% |
| 5 | 5 | 0.1% |
| 8 | 4 | 0.1% |
| 9 | 2 | 0.1% |
| 10 | 7 | 0.2% |
| 14 | 2 | 0.1% |
| 15 | 22 | |
| 16 | 3 | 0.1% |
| 18 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 10000 | 4 | 0.1% |
| 5000 | 42 | |
| 4000 | 3 | 0.1% |
| 3000 | 12 | 0.3% |
| 2000 | 12 | 0.3% |
| 1900 | 1 | < 0.1% |
| 1500 | 8 | 0.2% |
| 1200 | 15 | 0.4% |
| 1160 | 26 | |
| 1100 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| False | 3279 | |
| True | 453 | 12.1% |
quantity
Real number (ℝ)
| Distinct | 143 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 213.2709 |
| Minimum | 0 |
|---|---|
| Maximum | 1500 |
| Zeros | 6 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 50 |
| median | 186 |
| Q3 | 340 |
| 95-th percentile | 500 |
| Maximum | 1500 |
| Range | 1500 |
| Interquartile range (IQR) | 290 |
Descriptive statistics
| Standard deviation | 194.73098 |
|---|---|
| Coefficient of variation (CV) | 0.91306866 |
| Kurtosis | 1.9359411 |
| Mean | 213.2709 |
| Median Absolute Deviation (MAD) | 136 |
| Skewness | 1.1624395 |
| Sum | 795927 |
| Variance | 37920.153 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 200 | 417 | 11.2% |
| 500 | 400 | 10.7% |
| 1 | 285 | 7.6% |
| 100 | 284 | 7.6% |
| 400 | 206 | 5.5% |
| 250 | 166 | 4.4% |
| 50 | 123 | 3.3% |
| 300 | 93 | 2.5% |
| 150 | 92 | 2.5% |
| 20 | 80 | 2.1% |
| Other values (133) | 1586 |
| Value | Count | Frequency (%) |
| 0 | 6 | 0.2% |
| 1 | 285 | |
| 2 | 33 | 0.9% |
| 3 | 21 | 0.6% |
| 4 | 33 | 0.9% |
| 5 | 49 | 1.3% |
| 6 | 40 | 1.1% |
| 7 | 21 | 0.6% |
| 8 | 4 | 0.1% |
| 9 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 1500 | 2 | 0.1% |
| 1200 | 3 | 0.1% |
| 1100 | 3 | 0.1% |
| 1000 | 1 | < 0.1% |
| 975 | 4 | |
| 950 | 5 | |
| 900 | 8 | |
| 875 | 3 | 0.1% |
| 860 | 1 | < 0.1% |
| 850 | 3 | 0.1% |
price_per_kg
Real number (ℝ)
| Distinct | 961 |
|---|---|
| Distinct (%) | 25.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 4 |
| Infinite (%) | 0.1% |
| Mean | inf |
| Minimum | 0 |
|---|---|
| Maximum | inf |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9155.2759 |
| Q1 | 24400 |
| median | 46450 |
| Q3 | 82000 |
| 95-th percentile | 256403.45 |
| Maximum | inf |
| Range | inf |
| Interquartile range (IQR) | 57600 |
Descriptive statistics
| Standard deviation | nan |
|---|---|
| Coefficient of variation (CV) | nan |
| Kurtosis | nan |
| Mean | inf |
| Median Absolute Deviation (MAD) | 26100 |
| Skewness | nan |
| Sum | inf |
| Variance | nan |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25000 | 66 | 1.8% |
| 50000 | 44 | 1.2% |
| 100000 | 31 | 0.8% |
| 75000 | 26 | 0.7% |
| 47000 | 24 | 0.6% |
| 20000 | 24 | 0.6% |
| 117000 | 24 | 0.6% |
| 80000 | 24 | 0.6% |
| 60000 | 23 | 0.6% |
| 28500 | 22 | 0.6% |
| Other values (951) | 3424 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1724.137931 | 1 | < 0.1% |
| 1900 | 3 | |
| 2100 | 1 | < 0.1% |
| 2400 | 2 | |
| 2413.793103 | 1 | < 0.1% |
| 2600 | 1 | < 0.1% |
| 2800 | 2 | |
| 2900 | 1 | < 0.1% |
| 3000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| inf | 4 | |
| 12000000 | 2 | |
| 3380000 | 2 | |
| 2380000 | 2 | |
| 2043181.818 | 2 | |
| 1696666.667 | 2 | |
| 1664814.815 | 2 | |
| 1516666.667 | 2 | |
| 1419230.769 | 2 | |
| 1350000 | 2 |
total_revenue
Real number (ℝ)
Zeros
| Distinct | 572 |
|---|---|
| Distinct (%) | 15.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60103.982 |
| Minimum | 0 |
|---|---|
| Maximum | 839400 |
| Zeros | 454 |
| Zeros (%) | 12.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 14000 |
| median | 39500 |
| Q3 | 82200 |
| 95-th percentile | 178200 |
| Maximum | 839400 |
| Range | 839400 |
| Interquartile range (IQR) | 68200 |
Descriptive statistics
| Standard deviation | 74065.677 |
|---|---|
| Coefficient of variation (CV) | 1.2322924 |
| Kurtosis | 26.481113 |
| Mean | 60103.982 |
| Median Absolute Deviation (MAD) | 30100 |
| Skewness | 3.8897315 |
| Sum | 2.2430806 × 108 |
| Variance | 5.4857245 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 454 | 12.2% |
| 15000 | 33 | 0.9% |
| 59400 | 30 | 0.8% |
| 9000 | 27 | 0.7% |
| 48600 | 27 | 0.7% |
| 26400 | 26 | 0.7% |
| 45000 | 26 | 0.7% |
| 27000 | 26 | 0.7% |
| 54000 | 26 | 0.7% |
| 36000 | 24 | 0.6% |
| Other values (562) | 3033 |
| Value | Count | Frequency (%) |
| 0 | 454 | |
| 1000 | 9 | 0.2% |
| 1800 | 1 | < 0.1% |
| 2000 | 16 | 0.4% |
| 2300 | 3 | 0.1% |
| 2500 | 11 | 0.3% |
| 2700 | 3 | 0.1% |
| 2900 | 1 | < 0.1% |
| 3000 | 9 | 0.2% |
| 3200 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 839400 | 2 | |
| 783000 | 2 | |
| 744000 | 2 | |
| 685800 | 2 | |
| 623400 | 2 | |
| 621000 | 2 | |
| 599400 | 2 | |
| 590400 | 2 | |
| 555000 | 2 | |
| 539400 | 2 |
discountValue
Real number (ℝ)
Zeros
| Distinct | 104 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1487.283 |
| Minimum | 0 |
|---|---|
| Maximum | 120100 |
| Zeros | 1169 |
| Zeros (%) | 31.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 500 |
| Q3 | 1600 |
| 95-th percentile | 5800 |
| Maximum | 120100 |
| Range | 120100 |
| Interquartile range (IQR) | 1600 |
Descriptive statistics
| Standard deviation | 4066.5619 |
|---|---|
| Coefficient of variation (CV) | 2.7342221 |
| Kurtosis | 433.07718 |
| Mean | 1487.283 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 16.880563 |
| Sum | 5550540 |
| Variance | 16536926 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1169 | |
| 100 | 193 | 5.2% |
| 500 | 170 | 4.6% |
| 600 | 152 | 4.1% |
| 300 | 133 | 3.6% |
| 700 | 125 | 3.3% |
| 400 | 112 | 3.0% |
| 800 | 108 | 2.9% |
| 900 | 100 | 2.7% |
| 200 | 98 | 2.6% |
| Other values (94) | 1372 |
| Value | Count | Frequency (%) |
| 0 | 1169 | |
| 100 | 193 | 5.2% |
| 200 | 98 | 2.6% |
| 250 | 2 | 0.1% |
| 300 | 133 | 3.6% |
| 400 | 112 | 3.0% |
| 500 | 170 | 4.6% |
| 600 | 152 | 4.1% |
| 700 | 125 | 3.3% |
| 750 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 120100 | 2 | |
| 70000 | 2 | |
| 26400 | 3 | |
| 25000 | 2 | |
| 22500 | 2 | |
| 21600 | 2 | |
| 20000 | 4 | |
| 17800 | 2 | |
| 15000 | 2 | |
| 14800 | 4 |
Interactions
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Category | name | mrp | discountPercent | availableQuantity | discountedSellingPrice | weightInGms | outOfStock | quantity | price_per_kg | total_revenue | discountValue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Fruits & Vegetables | Onion | 2500 | 16 | 3 | 2100 | 1000 | False | 1 | 2100.000000 | 6300 | 400 |
| 1 | Fruits & Vegetables | Tomato Hybrid | 4200 | 16 | 3 | 3500 | 1000 | False | 1 | 3500.000000 | 10500 | 700 |
| 2 | Fruits & Vegetables | Tender Coconut | 5100 | 15 | 3 | 4300 | 58 | False | 1 | 74137.931034 | 12900 | 800 |
| 3 | Fruits & Vegetables | Coriander Leaves | 2000 | 15 | 3 | 1700 | 100 | False | 100 | 17000.000000 | 5100 | 300 |
| 4 | Fruits & Vegetables | Ladies Finger | 1400 | 14 | 3 | 1200 | 250 | False | 250 | 4800.000000 | 3600 | 200 |
| 5 | Fruits & Vegetables | Potato | 3500 | 17 | 3 | 2900 | 1000 | False | 1 | 2900.000000 | 8700 | 600 |
| 6 | Fruits & Vegetables | Lemon | 7500 | 16 | 3 | 6300 | 200 | False | 200 | 31500.000000 | 18900 | 1200 |
| 7 | Fruits & Vegetables | Watermelon | 5800 | 15 | 3 | 4900 | 58 | False | 1 | 84482.758621 | 14700 | 900 |
| 8 | Fruits & Vegetables | Capsicum Green | 2300 | 17 | 3 | 1900 | 250 | False | 250 | 7600.000000 | 5700 | 400 |
| 9 | Fruits & Vegetables | Chilli Green | 1900 | 15 | 3 | 1600 | 100 | False | 100 | 16000.000000 | 4800 | 300 |
| Category | name | mrp | discountPercent | availableQuantity | discountedSellingPrice | weightInGms | outOfStock | quantity | price_per_kg | total_revenue | discountValue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3722 | Health & Hygiene | Eno Cooling Sachets - Cool Mint, 6 Pieces Carton | 5400 | 11 | 0 | 4800 | 5 | True | 5 | 960000.000000 | 0 | 600 |
| 3723 | Health & Hygiene | Whisper Choice Sanitary Pad | 3200 | 9 | 0 | 2900 | 406 | True | 7 | 7142.857143 | 0 | 300 |
| 3724 | Health & Hygiene | Whisper Bindazzz Nights XL + Sanitary Pad | 9000 | 0 | 0 | 9000 | 406 | True | 7 | 22167.487685 | 0 | 0 |
| 3725 | Health & Hygiene | Gillette Venus Close & Clean Razor | 24900 | 7 | 0 | 23000 | 58 | True | 1 | 396551.724138 | 0 | 1900 |
| 3726 | Health & Hygiene | Whisper Choice Regular Sanitary Pads | 9000 | 3 | 0 | 8700 | 58 | True | 20 | 150000.000000 | 0 | 300 |
| 3727 | Health & Hygiene | Stayfree Secure Dry Cover Extra Large Sanitary Pad | 4200 | 2 | 0 | 4100 | 406 | True | 7 | 10098.522167 | 0 | 100 |
| 3728 | Health & Hygiene | Dabur Honitus Herbal Cough Remedy Ayurvedic Syrup | 10500 | 15 | 0 | 8900 | 100 | True | 100 | 89000.000000 | 0 | 1600 |
| 3729 | Health & Hygiene | Whisper Bindazzz Night Sanitary Pads XL Plus | 18500 | 0 | 0 | 18500 | 870 | True | 15 | 21264.367816 | 0 | 0 |
| 3730 | Health & Hygiene | Fine Life Cotton Balls | 6000 | 0 | 0 | 6000 | 50 | True | 50 | 120000.000000 | 0 | 0 |
| 3731 | Health & Hygiene | Dettol Antiseptic Liquid | 3000 | 0 | 0 | 3000 | 60 | True | 60 | 50000.000000 | 0 | 0 |
Duplicate rows
Most frequently occurring
| Category | name | mrp | discountPercent | availableQuantity | discountedSellingPrice | weightInGms | outOfStock | quantity | price_per_kg | total_revenue | discountValue | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Paan Corner | Listerine Cool Mint Mouthwash - Mild Taste | 15000 | 10 | 6 | 13500 | 250 | False | 250 | 54000.0 | 81000 | 1500 | 2 |
| 1 | Personal Care | Listerine Cool Mint Mouthwash - Mild Taste | 15000 | 10 | 6 | 13500 | 250 | False | 250 | 54000.0 | 81000 | 1500 | 2 |